CustomerOrderProductLineItem

Entity Definition

Logical Name : CustomerOrderProductLineItem
Physical Name : DO_CTOLTM_PDT

A line item component of a Customer placed order, recording the StockItem, and quantity that is to be supplied.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerOrderID (FK)(PK) A unique system assigned identifier for the CustomerOrder. ID_ORD Identity integer
CustomerOrderLineItemSequenceNumber (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM LineNumber smallint
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)
Description The textual description of the Item being ordered and its characteristics. DE_ITM DescriptionShort varchar(255)
OrderedItemQuantity The number of Items being ordered. QU_ORD_CNT Quantity DECIMAL(9,3)
FulfilledItemQuantity The number of ordered items that have been made available for delivery to the Customer or pickup by the Customer. QU_FLF_CNT Quantity DECIMAL(9,3)
SaleUnitRetailPriceAmount The agreed unit retail selling price for the merchandise being ordered, RP_SLS_UN MoneyShortRetail decimal(7,2)
TotalRetailPriceAmount The agreed retail selling price for all the merchandise being ordered on this line item. Would usually be calculated by multiplying SaleUnitRetailPriceAmount by OrderedCount - but this may differ. MO_PRC_TOT Money decimal(16,5)
EstimatedAvailabilityDate The date the merchandise being ordered is expected to be available for delivery to the Customer or pickup by the Customer. DC_AVLB_EST DateCalendar date
ActualAvailabilityDate The date all the merchandise being ordered was made available for delivery to the Customer or pickup by the Customer. Where the merchandise becomes available over a period of time - this field holds the date the last ordered product was available for delivery or pickup. DC_AVLB_ACT DateCalendar date

Relationships

Parent Entity Verb Phrase Child Entity
Item is ordered via CustomerOrderProductLineItem
CustomerOrderProductLineItem is assigned to CustomerOrderProductAssignment
CustomerOrderProductLineItem has CustomerOrderProductPriceModifier
CustomerOrderProductLineItem is charged with CustomerOrderProductTaxLineItem
CustomerOrderProductLineItem has CustomerOrderProductSpecialInstructions
CustomerOrderProductLineItem causes creation of ICDMerchandiseLineItem
CustomerOrderLineItem can be a CustomerOrderProductLineItem

Logical Views containing CustomerOrderProductLineItem

Logical View
Logical 02200 - Transaction Macro View
Logical 02309 - Retail Transaction Delivery
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 07600 - Customer Order - Macro View
Logical 07610 - Customer Order - Maintenance View
Logical 07620 - Customer Order - Inventory Control View
Logical 10400 - Enterprise - Channels